aUSD

Row

Components of Total Value Locked

Row

aUSD Issuance

blockAcala blockKarura Date aUSD_Karura aUSD_Acala aUSD_Total
382,658 1,498,135 2022-02-10 5,767,842 1,828,453 7,596,295
389,478 1,502,412 2022-02-11 5,650,252 2,717,049 8,367,301
396,298 1,506,675 2022-02-12 5,646,145 2,936,480 8,582,624
403,080 1,510,965 2022-02-13 5,856,542 2,983,693 8,840,235
409,851 1,515,339 2022-02-14 5,841,993 3,035,791 8,877,784
416,618 1,519,779 2022-02-15 5,860,838 3,737,926 9,598,764
423,364 1,524,208 2022-02-16 5,821,150 4,175,472 9,996,623
429,431 1,528,534 2022-02-17 5,721,577 4,597,237 10,318,814
435,379 1,532,831 2022-02-18 5,648,546 4,686,985 10,335,531
441,244 1,537,082 2022-02-19 5,553,868 4,817,623 10,371,492
447,046 1,541,290 2022-02-20 5,281,255 5,250,047 10,531,302
452,805 1,545,293 2022-02-21 5,215,281 5,577,267 10,792,548
458,591 1,549,212 2022-02-22 5,018,519 5,290,149 10,308,668
464,375 1,553,133 2022-02-23 4,970,303 5,276,073 10,246,375
470,299 1,557,141 2022-02-24 4,643,933 4,943,368 9,587,301
476,519 1,561,208 2022-02-25 4,675,561 4,978,260 9,653,820
483,026 1,565,186 2022-02-26 4,676,162 5,039,742 9,715,904
489,670 1,569,198 2022-02-27 4,627,923 5,069,752 9,697,675
496,214 1,573,192 2022-02-28 4,673,425 5,143,742 9,817,167
502,741 1,577,360 2022-03-01 4,728,346 5,195,708 9,924,053
509,328 1,581,658 2022-03-02 4,750,544 5,270,660 10,021,204
515,915 1,586,008 2022-03-03 4,682,114 6,025,456 10,707,570
522,577 1,590,339 2022-03-04 4,617,155 5,964,756 10,581,911
529,288 1,594,558 2022-03-05 4,588,524 5,990,488 10,579,012
535,942 1,598,920 2022-03-06 4,592,027 6,003,125 10,595,152
542,760 1,603,233 2022-03-07 4,572,082 6,171,523 10,743,606
549,653 1,607,573 2022-03-08 4,570,846 6,173,255 10,744,100
556,567 1,611,910 2022-03-09 4,671,687 6,207,245 10,878,932
563,674 1,616,357 2022-03-10 4,568,758 6,239,169 10,807,927
570,668 1,620,876 2022-03-11 4,579,459 6,399,362 10,978,821
577,693 1,625,432 2022-03-12 4,581,608 6,451,874 11,033,483
584,752 1,629,884 2022-03-13 4,537,367 6,462,624 10,999,991
591,860 1,634,405 2022-03-14 4,504,974 6,555,472 11,060,446
598,871 1,638,930 2022-03-15 4,517,668 6,576,152 11,093,820
605,882 1,643,457 2022-03-16 4,550,885 6,662,331 11,213,216
612,917 1,647,983 2022-03-17 4,590,944 6,739,440 11,330,384
620,006 1,652,652 2022-03-18 4,675,263 6,813,161 11,488,424
627,056 1,657,396 2022-03-19 4,724,276 6,816,139 11,540,415
634,100 1,662,219 2022-03-20 4,750,389 6,824,157 11,574,546
641,175 1,666,997 2022-03-21 4,805,186 6,895,101 11,700,287
648,244 1,671,509 2022-03-22 4,827,630 7,026,981 11,854,611
655,070 1,675,850 2022-03-23 4,865,881 6,974,154 11,840,035
661,932 1,680,082 2022-03-24 4,857,238 7,027,391 11,884,629
668,922 1,684,322 2022-03-25 4,869,007 7,144,140 12,013,147
675,883 1,688,574 2022-03-26 4,849,235 7,238,112 12,087,347
682,919 1,692,713 2022-03-27 4,895,435 7,492,344 12,387,779
689,974 1,696,873 2022-03-28 4,930,751 7,605,614 12,536,365
697,050 1,700,908 2022-03-29 5,067,601 7,741,578 12,809,179
704,068 1,704,922 2022-03-30 5,130,914 7,818,922 12,949,836
711,104 1,708,906 2022-03-31 5,239,132 7,864,343 13,103,475
718,140 1,712,970 2022-04-01 5,202,627 6,582,120 11,784,747
725,135 1,717,078 2022-04-02 5,278,899 6,826,597 12,105,496
732,169 1,721,276 2022-04-03 5,282,403 6,843,151 12,125,554
739,232 1,725,277 2022-04-04 5,155,766 6,900,641 12,056,407
746,312 1,729,249 2022-04-05 5,172,532 6,964,965 12,137,497
753,339 1,733,105 2022-04-06 5,083,636 6,850,470 11,934,106
760,400 1,736,920 2022-04-07 5,356,936 6,933,225 12,290,161
767,454 1,740,728 2022-04-08 5,333,274 7,042,668 12,375,942
774,447 1,744,511 2022-04-09 5,305,469 7,217,070 12,522,539
781,545 1,748,342 2022-04-10 5,351,529 7,218,353 12,569,882
788,553 1,752,148 2022-04-11 5,148,440 7,222,597 12,371,037
795,620 1,756,009 2022-04-12 5,168,805 7,265,808 12,434,614
802,608 1,759,810 2022-04-13 5,166,177 7,391,025 12,557,203
809,644 1,763,619 2022-04-14 5,181,003 7,582,148 12,763,152
816,668 1,767,375 2022-04-15 5,225,609 7,632,200 12,857,809
823,732 1,771,087 2022-04-16 5,231,498 7,625,873 12,857,371
830,766 1,774,902 2022-04-17 5,221,374 7,662,176 12,883,549
837,826 1,778,708 2022-04-18 5,204,413 7,690,803 12,895,216
844,870 1,782,472 2022-04-19 5,197,599 7,797,376 12,994,975
851,796 1,786,343 2022-04-20 5,234,624 7,782,928 13,017,552
858,830 1,790,294 2022-04-21 5,315,784 7,720,130 13,035,914
865,842 1,794,197 2022-04-22 5,277,628 7,795,274 13,072,902
872,830 1,798,162 2022-04-23 5,548,256 7,784,345 13,332,601
879,807 1,802,115 2022-04-24 5,465,898 7,748,606 13,214,504
886,715 1,806,087 2022-04-25 5,464,495 7,708,251 13,172,746
893,713 1,810,046 2022-04-26 5,443,354 7,676,992 13,120,346
900,680 1,814,021 2022-04-27 5,414,557 7,698,776 13,113,334
907,463 1,817,974 2022-04-28 5,417,024 7,711,733 13,128,757
914,420 1,821,980 2022-04-29 5,401,302 7,646,778 13,048,079
921,375 1,826,039 2022-04-30 5,325,695 7,363,469 12,689,164
928,262 1,830,125 2022-05-01 5,308,806 7,296,870 12,605,676
935,210 1,834,044 2022-05-02 5,290,063 7,305,066 12,595,129
941,991 1,837,991 2022-05-03 5,289,398 7,326,266 12,615,664
948,773 1,841,986 2022-05-04 5,297,538 7,377,038 12,674,576
955,553 1,846,132 2022-05-05 5,283,745 7,300,340 12,584,084
962,314 1,850,190 2022-05-06 5,288,666 7,277,406 12,566,072
969,145 1,854,421 2022-05-07 5,234,538 9,743,345 14,977,883
975,941 1,858,658 2022-05-08 5,049,196 9,491,303 14,540,499
982,741 1,862,992 2022-05-09 4,856,056 8,582,048 13,438,104
989,571 1,867,957 2022-05-10 4,445,392 8,719,668 13,165,060
996,410 1,873,972 2022-05-11 3,975,273 6,972,738 10,948,011
1,003,195 1,880,188 2022-05-12 3,790,518 5,623,934 9,414,452
1,010,207 1,886,554 2022-05-13 3,828,842 5,803,385 9,632,227
1,017,179 1,892,961 2022-05-14 3,812,935 5,818,547 9,631,483
1,024,222 1,899,371 2022-05-15 3,856,292 5,927,092 9,783,384
1,031,247 1,905,778 2022-05-16 3,925,850 5,952,977 9,878,827
1,038,263 1,912,230 2022-05-17 3,977,072 6,008,718 9,985,790
1,044,985 1,918,591 2022-05-18 3,942,409 5,996,488 9,938,898
1,051,890 1,924,950 2022-05-19 3,999,092 5,979,944 9,979,036
1,058,796 1,931,289 2022-05-20 3,997,746 5,973,335 9,971,081
1,065,696 1,937,640 2022-05-21 4,028,271 5,991,504 10,019,775
1,072,674 1,944,002 2022-05-22 4,053,215 6,016,222 10,069,437
1,079,644 1,950,438 2022-05-23 4,092,102 6,049,078 10,141,180
1,086,605 1,956,833 2022-05-24 4,104,772 6,095,595 10,200,367
1,093,548 1,963,028 2022-05-25 4,100,411 6,116,611 10,217,022
1,100,467 1,969,604 2022-05-26 4,072,206 6,058,377 10,130,583
1,107,371 1,975,998 2022-05-27 4,055,514 6,022,962 10,078,476
1,114,253 1,982,535 2022-05-28 4,063,472 6,057,937 10,121,410
1,121,139 1,988,972 2022-05-29 4,065,723 6,081,219 10,146,942
1,128,033 1,995,443 2022-05-30 4,075,179 6,121,133 10,196,312
1,134,939 2,001,782 2022-05-31 4,196,753 6,132,025 10,328,778
1,141,677 2,008,273 2022-06-01 4,184,512 6,138,539 10,323,051
1,148,531 2,014,698 2022-06-02 4,192,668 6,208,705 10,401,373
1,155,361 2,021,059 2022-06-03 4,151,279 6,161,418 10,312,697
1,162,191 2,027,513 2022-06-04 4,154,170 6,110,974 10,265,145
1,168,945 2,034,053 2022-06-05 4,166,220 6,123,639 10,289,859
1,175,760 2,040,490 2022-06-06 4,179,423 6,143,116 10,322,540
1,182,503 2,046,816 2022-06-07 4,177,516 6,141,992 10,319,507
1,189,273 2,053,305 2022-06-08 4,178,977 6,137,929 10,316,907
1,196,022 2,059,744 2022-06-09 4,177,130 6,170,211 10,347,341
1,202,808 2,066,092 2022-06-10 4,149,014 6,136,321 10,285,335
1,209,560 2,072,325 2022-06-11 4,102,379 6,074,914 10,177,292
1,216,309 2,078,699 2022-06-12 4,004,056 5,891,343 9,895,398
1,222,967 2,084,974 2022-06-13 3,729,152 5,577,153 9,306,304
1,229,621 2,091,245 2022-06-14 3,735,276 5,568,632 9,303,909
1,236,320 2,097,549 2022-06-15 3,788,931 5,315,691 9,104,622
1,242,989 2,103,874 2022-06-16 3,784,345 5,287,516 9,071,861
1,249,647 2,110,292 2022-06-17 3,780,450 5,278,713 9,059,163
1,256,310 2,116,724 2022-06-18 3,744,797 5,247,145 8,991,943
1,263,003 2,123,104 2022-06-19 3,770,456 5,272,379 9,042,835
1,269,614 2,129,497 2022-06-20 3,773,566 4,741,005 8,514,571
1,276,376 2,135,922 2022-06-21 3,819,698 4,369,718 8,189,416
1,283,096 2,142,278 2022-06-22 3,827,112 4,370,810 8,197,922
1,289,783 2,148,575 2022-06-23 3,829,884 4,383,622 8,213,505
1,296,569 2,155,139 2022-06-24 3,832,776 4,397,323 8,230,099
1,303,311 2,161,562 2022-06-25 3,852,269 4,383,177 8,235,446
1,310,012 2,168,013 2022-06-26 3,876,004 4,374,412 8,250,416
1,316,693 2,173,904 2022-06-27 3,839,320 4,375,858 8,215,178
1,323,587 2,179,759 2022-06-28 3,806,037 4,373,729 8,179,766
1,330,303 2,185,605 2022-06-29 3,806,447 4,356,996 8,163,443
1,337,106 2,191,479 2022-06-30 3,774,174 4,331,462 8,105,636
1,343,825 2,197,147 2022-07-01 3,780,968 4,341,066 8,122,034
1,350,568 2,202,851 2022-07-02 3,806,688 4,354,300 8,160,989
1,357,347 2,208,544 2022-07-03 3,808,055 4,364,355 8,172,409
1,364,102 2,214,453 2022-07-04 3,812,428 4,372,827 8,185,255
1,370,943 2,220,335 2022-07-05 3,814,667 4,361,714 8,176,381
1,377,797 2,226,215 2022-07-06 3,815,652 4,364,384 8,180,036
1,384,635 2,232,059 2022-07-07 3,828,444 4,348,406 8,176,850
1,391,485 2,237,967 2022-07-08 3,837,918 4,347,524 8,185,442
1,398,299 2,243,857 2022-07-09 3,838,538 4,359,566 8,198,105
1,405,185 2,249,769 2022-07-10 3,840,756 4,352,234 8,192,990
1,411,909 2,255,713 2022-07-11 4,109,701 4,392,931 8,502,632
1,418,742 2,261,599 2022-07-12 4,107,944 4,358,631 8,466,575
1,425,585 2,267,294 2022-07-13 4,111,157 4,375,114 8,486,271
1,432,337 2,273,077 2022-07-14 4,111,947 4,374,531 8,486,478
1,439,201 2,278,953 2022-07-15 4,116,349 4,358,426 8,474,775
1,446,008 2,284,856 2022-07-16 4,116,661 4,348,617 8,465,278
1,452,960 2,290,692 2022-07-17 4,103,475 4,358,982 8,462,457
1,459,795 2,296,494 2022-07-18 4,111,415 4,398,737 8,510,151
1,466,580 2,302,426 2022-07-19 4,120,933 4,454,538 8,575,471
1,473,380 2,308,357 2022-07-20 4,126,611 4,500,049 8,626,660
1,480,245 2,314,283 2022-07-21 4,135,964 4,499,787 8,635,751
1,487,055 2,320,158 2022-07-22 4,227,100 4,533,147 8,760,248
1,493,873 2,326,054 2022-07-23 4,262,965 4,597,204 8,860,169
1,500,756 2,332,160 2022-07-24 4,266,207 4,605,889 8,872,096
1,507,666 2,338,259 2022-07-25 4,265,334 4,580,132 8,845,466
1,514,538 2,344,082 2022-07-26 4,193,132 4,577,767 8,770,899
1,521,363 2,349,718 2022-07-27 4,212,560 4,613,498 8,826,057
1,528,147 2,355,349 2022-07-28 4,216,008 4,623,185 8,839,193
1,535,018 2,360,978 2022-07-29 4,222,698 4,634,895 8,857,593
1,541,851 2,366,635 2022-07-30 4,258,459 4,640,917 8,899,376
1,548,704 2,372,202 2022-07-31 4,262,927 4,660,909 8,923,837
1,555,507 2,377,806 2022-08-01 4,267,948 5,783,151 10,051,099
1,562,419 2,383,360 2022-08-02 4,717,685 5,761,618 10,479,303
1,569,336 2,388,999 2022-08-03 4,720,206 5,756,487 10,476,693
1,576,157 2,394,583 2022-08-04 4,709,731 5,800,920 10,510,651
1,583,026 2,400,226 2022-08-05 4,719,403 5,854,369 10,573,772
1,589,971 2,406,084 2022-08-06 4,723,547 5,925,218 10,648,764
1,596,911 2,411,957 2022-08-07 4,723,069 5,941,852 10,664,921
1,603,908 2,417,831 2022-08-08 4,752,236 6,012,468 10,764,704
1,610,881 2,423,819 2022-08-09 4,763,845 6,113,350 10,877,195
1,617,841 2,429,866 2022-08-10 4,794,960 6,211,274 11,006,234
1,624,758 2,435,795 2022-08-11 4,801,615 6,274,030 11,075,645
1,631,646 2,441,583 2022-08-12 4,809,207 6,355,909 11,165,116
1,631,831 2,441,896 2022-08-13 4,809,268 6,356,619 11,165,888

Row

Sources and Notes

Please click on the Source Code link at the top of the document to see the full source code. Here is a summary:

aUSD

  • aUDS (or kUSD) obtained from the py-substrate-interface using function substrate.query(module=‘Tokens’,storage_function=‘TotalIssuance’, params = [{‘Token’: ‘AUSD’}], block_hash = hash)
---
title: "Acala / Karura aUSD Dashboard"
output:
  flexdashboard::flex_dashboard:
    orientation: rows
    vertical_layout: scroll
    social: menu
    source_code: embed

---

```{css custom1, echo=FALSE}
.dataTables_scrollBody {
    max-height: 100% !important;
}
```

```{r global, include=FALSE}
library(knitr)
knitr::opts_chunk$set(
  message = FALSE,
  warning = FALSE,
  comment = "#>"
)

library(ggplot2)
# library(dygraphs)
library(kableExtra)
library(formattable)
library(lubridate)
library(flexdashboard)
library(DT)
library(subscanr)
library(formattable)
library(ghql)
x <- GraphqlClient$new()

# Helper function to concat
`%+%` <- function(a, b) paste0(a, b)

window <- today() - as.Date("2021-12-31") + 1

# Liquidity Pool TVL ($3.72M) = totalDefiTvl = totalDexTvl + totalDexLockedTvl + homaLocked + stableCoinTvl
kdex <- getDailyPools_acala_dex("karura", window) %>%
  setorder(Date, pair)
adex <- getDailyPools_acala_dex("acala", window) %>%
  setorder(Date, pair)
adaily <- adex[, max(updateAtBlock.id), by = Date] %>%
  setnames("V1", "blockAcala")
kdaily <- kdex[, max(updateAtBlock.id), by = Date] %>%
  setnames("V1", "blockKarura")
dailyTVL <- merge(adaily, kdaily, by = 'Date')

library(reticulate)
# use_python("/opt/homebrew/bin/python3.9")
```

```{python, include=FALSE}
from substrateinterface import SubstrateInterface

import pandas as pd

def getTotalIssuance(network):
    if network=="Karura":
        url = 'wss://karura.polkawallet.io'
        token = 'KUSD'
    else:
        url = 'wss://acala-rpc-0.aca-api.network'
        token = 'AUSD'

    substrate = SubstrateInterface(url)
    data = []
    for block_id in r.blocks:
        hash = substrate.get_block_hash(int(block_id))
        ausd = substrate.query(module='Tokens',storage_function='TotalIssuance', params = [{'Token': token}], block_hash = hash)
        outi = {"Block": block_id, 'aUSD': ausd.value / 10**12}
        data.append(outi)
    
    out = pd.DataFrame(data)
    return out

```



```{r tvl, cache = TRUE, include=FALSE}

  blocks = as.character(dailyTVL$blockKarura)
  kusd = py$getTotalIssuance("Karura")
  
  blocks = as.character(dailyTVL$blockAcala)
  ausd = py$getTotalIssuance("Acala")

  dailyTVL[, blockAcala  := as.numeric(blockAcala)]  
  dailyTVL[, blockKarura := as.numeric(blockKarura)]  
  kusd$Block <- as.numeric(kusd$Block)
  ausd$Block <- as.numeric(ausd$Block)
  
  dailyTVL <- merge(dailyTVL, kusd, by.x = "blockKarura", by.y = "Block") %>%
    setnames("aUSD", "aUSD_Karura")
  dailyTVL <- merge(dailyTVL, ausd, by.x = "blockAcala", by.y = "Block") %>%
    setnames("aUSD", "aUSD_Acala")
  dailyTVL[, aUSD_Total := aUSD_Karura + aUSD_Acala]
  
  fwrite(x = dailyTVL, file = "aUSD_Issuance.csv")

```

# aUSD {.tabset}

Row
----

### Components of Total Value Locked

```{r k_plot1}

dat <- melt(data = dailyTVL[, .(Date, aUSD_Karura, aUSD_Acala)], 
      id.vars = "Date",
      value.name = "aUSD")
dat[, aUSD := aUSD / 1e6]
 
# Stacked
ggplot(dat, aes(fill=variable, y=aUSD, x=Date)) + 
    geom_bar(position="stack", stat="identity") +
    ggtitle(label="Issuance of aUSD") + 
    ylab("aUSD (in millions USD)")

```

Row
----

### aUSD Issuance

```{r ausd}

knitr::kable(dailyTVL, escape = FALSE, format.args = list(big.mark = ",")) %>%
  kable_styling()

```

Row
----

### Sources and Notes

Please click on the *Source Code* link at the top of the document to see the full source code.  Here is a summary:

#### aUSD
- aUDS (or kUSD) obtained from the [py-substrate-interface](https://github.com/polkascan/py-substrate-interface) using function *substrate.query(module='Tokens',storage_function='TotalIssuance', params = [{'Token': 'AUSD'}], block_hash = hash)*